SET NOCOUNT ON
GO
--USE [ManageSchool]
--GO
CREATE PROCEDURE [dbo].[pr_Session_SelectAll]
	@UserName varchar(30)
AS
SELECT * FROM [dbo].[tblSession]
WHERE
	[UserName]=@UserName 
ORDER BY 
	[UserName] ASC
GO

------

CREATE PROCEDURE [dbo].[pr_Session_Insert]
	@UserName varchar(30),
	@LoginTime char(30)
As
INSERT [dbo].[tblSession]
(
	[UserName],
	[LoginTime]
)
VALUES
(
	@UserName,
	@LoginTime
)
GO
----
exec pr_Session_SelectAll '123'